Indexing

		In order to search on a field, that field must be indexed.
		Show me
		There are two main reasons for indexing a field:
		So you can search on that field in the Find window
		So you can produce Flash Reports in the Tables screen
		To add an index
		Click the Add button
		Enter a name for the index This is usually the same as the field name Eg. No. of employees
		Select the field to be indexed Eg. No. of employees
		When you select the field to be indexed, the same field will also be displayed as it appears for the other types of records. This is because the data structure is the same for a Company, Contact, Family and Asset, you just use different field names for each type. Therefore, indexing on User-defined 50 for a Company will also index on User-defined 50 for a Contact, Family and Asset. You cannot index on just a Company field. However, when you search, the program will understand what type of information you are searching for, and in the case of Flash Reports you can specify the type directly.
		To delete an index
		Select an index from the list Indexes with a  lock icon cannot be deleted
		Click the Delete button
		To rename an index
		Select an index from the list
		Click the Edit button
		Enter a new name for the index
		Choose OK
		Available for searching in the Find window
		If this option is ticked, the selected index will appear as a choice in the Find window. All indexes are available for Flash Reports.
		Rebuilding indexes
		It should not be necessary to rebuild the indexes as the program automatically updates the indexes whenever you add or edit the database. However, you do need to rebuild the indexes after importing data, as new data is not added to the index automatically in case it doesn't import how you expected it to. To rebuild an index:
		Click the Rebuild button
		Select the indexes you want to rebuild
		Click the Start button
		Note Other users cannot search the database while the indexes are being rebuilt, so on a network you should rebuild the indexes when it will affect the least number of users.
		Note Changes made in this section will affect all users.
		Tech Note Index files are stored in the Indexes folder with the extension .bin (binary). Related topics Database fields